package com.cn.jdia.tas.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.cn.jdia.tas.model.T_attrecord;

public interface T_attrecordMapper {
	int deleteByPrimaryKey(Integer attrecordid);

	int insert(T_attrecord record);

	int insertSelective(T_attrecord record);

	T_attrecord selectByPrimaryKey(Integer attrecordid);

	int updateByPrimaryKeySelective(T_attrecord record);

	int updateByPrimaryKey(T_attrecord record);

	List<T_attrecord> getAttrecords(String start, String end);

	List<T_attrecord> getAttrecordsWithName(String start, String end);

	List<T_attrecord> getpersonDetailRecord(String id, String start, String end);

	List<T_attrecord> selectdeptrcd(String deptid, String date);

	List<T_attrecord> queryInterestRecord(@Param("date") String date, @Param("list") List<String> interestList);

	int queryCountByDay(String date);

	int queryLateCount(String date);

	int queryMaxAttrecordId();

	List<T_attrecord> selectGroupRecord(@Param("date") String date, @Param("list") List<String> employeeidList);

	//查询全部门所有专业线数据
	List<T_attrecord> selectParentdeptRcd(String deptid, String date);
	
	List<Map<String,Object>> querydLevel2DeptCount(String deptid, String date);
	
	List<Map<String,Object>> querydFullLevel2DeptCount(String deptid, String date);
	
	//全部门的
	List<T_attrecord> selectFullDeptRcd(String deptid, String date);
	
	//含子部门的迟到人员
	List<T_attrecord> selectParentDeptLateRecord(String date,String deptid);
	
	//不含子部门的迟到人员
	List<T_attrecord> selectChildDeptLateRecord(String date,String deptid);
	
	//含子部门的外勤签到总数
	int selectParentOutcheckMemberCount(String date,String deptid);
	
	//含子部门的外勤签到明细
	List<T_attrecord>  selectParentOutcheckRecord(String date,String deptid);
	
	//导出部门excel用，含专业线的总部门
	List<T_attrecord> selectParentDepetMutilRecords(String deptid,String start,String end);
	
	//导出部门excel用，不含专业线的部门
	List<T_attrecord> selectChildDepetMutilRecords(String deptid,String start,String end);
	
	
}